<?php
/**
 * 本破解程序由资源邦提供
 * 更多微擎模块和小程序请访问资源邦官网：www.wazyb.com
 * QQ:993424780  承接网站建设、公众号搭建、小程序建设、企业网站
 */
pdo_query("CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_active` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`sort` int(10),
`pid` int(10),
`hits` int(10),
`status` tinyint(10),
`thumb` varchar(200),
`money` float(10,2),
`cityid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_adv` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11),
`advname` varchar(50),
`link` varchar(255),
`thumb` varchar(255),
`displayorder` int(11),
`enabled` int(11),
`toway` varchar(30),
`appid` varchar(50),
PRIMARY KEY (`id`),
KEY `indx_weid` (`weid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_agent` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50),
`password` varchar(50),
`thumb` text,
`tel` varchar(30),
`qq` varchar(30),
`address` varchar(50),
`createtime` int(10),
`uniacid` int(10),
`uid` int(10),
`enabled` tinyint(10),
`content` text,
`sort` int(10),
`intro` varchar(200),
`cityid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`name` varchar(50),
`sort` int(11),
`enabled` int(11),
`cityid` int(10),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_baoming` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50),
`tel` varchar(30),
`companyname` varchar(50),
`createtime` int(10),
`uniacid` int(10),
`aid` int(10),
`pid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_case` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`sort` int(10),
`hits` int(10),
`status` tinyint(10),
`thumb` varchar(200),
`isrecommand` tinyint(10),
`teamid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_category` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) unsigned NOT NULL,
`name` varchar(50) NOT NULL,
`thumb` varchar(255) NOT NULL,
`parentid` int(10) unsigned NOT NULL,
`isrecommand` int(10),
`description` varchar(500) NOT NULL,
`displayorder` tinyint(3) unsigned NOT NULL,
`enabled` tinyint(1) unsigned NOT NULL,
`model` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`name` varchar(50),
`sort` int(11),
`enabled` int(11),
`ishot` tinyint(10),
`firstname` varchar(30),
`ison` tinyint(10),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_comment` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`houseid` int(10),
`type` varchar(30),
`content` varchar(200),
`createtime` int(10),
`uniacid` int(10),
`uid` int(10),
`status` tinyint(10),
`score` tinyint(10),
`pid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_complain` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50),
`tel` varchar(30),
`content` varchar(50),
`createtime` int(10),
`uniacid` int(10),
`agentid` int(10),
`uid` int(10),
`status` tinyint(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`sort` int(10),
`pid` int(10),
`sid` int(10),
`hits` int(10),
`status` tinyint(10),
`thumb` varchar(200),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_coupon` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`uid` int(10),
`name` varchar(200),
`tel` varchar(60),
`createtime` int(10) unsigned NOT NULL,
`status` tinyint(10),
`weixin` varchar(30),
`tid` int(10),
`fid` int(10),
`money` float(10,2),
`dmoney` float(10,2),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_fxmessage` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50),
`tel` varchar(30),
`createtime` int(10),
`uniacid` int(10),
`uid` int(10),
`tid` int(10),
`fxuid1` int(10),
`fxuid2` int(10),
`status` tinyint(10),
`pid` int(10),
`fxmoney` float(10,2),
`type` tinyint(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_fxrecord` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`createtime` int(10),
`uniacid` int(10),
`uid` int(10),
`status` tinyint(10),
`money` float(10,2),
`orderid` int(10),
`content` varchar(50),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_house` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`sort` int(10),
`hits` int(10),
`status` tinyint(10),
`thumb` varchar(200),
`isrecommand` tinyint(10),
`teamid` int(10),
`money` float(10,2),
`dmoney` float(10,2),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_houseinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`housename` varchar(200),
`companyname` varchar(50),
`houseprice` int(10),
`housetype` int(10),
`houseareaid` int(10),
`houseaddress` varchar(30),
`housesaleaddress` varchar(30),
`houserate` varchar(30),
`housegreenrate` varchar(50),
`housecovered` varchar(50),
`buildarea` varchar(60),
`opensaletime` varchar(60),
`staytime` varchar(60),
`productspecial` varchar(60),
`houseschool` varchar(60),
`housebus` varchar(60),
`housestatus` tinyint(10),
`thumb` varchar(200),
`isrecommand` tinyint(10),
`sort` int(10),
`createtime` int(10),
`content` text,
`tel` varchar(30),
`thumb_url` text,
`lng` decimal(10,6),
`lat` decimal(10,6),
`fxmoney` float(10,2),
`cityid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_housemsg` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`houseid` int(10),
`toplistid` int(10),
`name` varchar(50),
`tel` varchar(30),
`paystatus` tinyint(10),
`createtime` int(10),
`uniacid` int(10),
`uid` int(10),
`status` tinyint(10),
`type` varchar(30),
`content` varchar(100),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_houseprice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`name` varchar(50),
`beginprice` int(10),
`endprice` int(10),
`sort` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_intro` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`name` varchar(100),
`logo` varchar(150),
`address` varchar(200),
`tel` varchar(50),
`opentime` varchar(30),
`lng` decimal(10,6),
`lat` decimal(10,6),
`qq` varchar(50),
`email` varchar(50),
`city` varchar(30),
`ischeck` tinyint(10),
`fxbanner` varchar(150),
`maincolor` varchar(30),
`moban` tinyint(10),
`rate1` float(10,2),
`rate2` float(10,2),
`ispay` tinyint(10),
`isoldhouse` tinyint(10),
`islethouse` tinyint(10),
`isbuyhouse` tinyint(10),
`issalehouse` tinyint(10),
`isagentoldhouse` tinyint(10),
`isagentlethouse` tinyint(10),
`isgetuser` tinyint(10),
`newlimit` int(10),
`oldlimit` int(10),
`letlimit` int(10),
`ischeck2` tinyint(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_lethouseinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`money` int(10),
`roomid` int(10),
`roomtype` varchar(30),
`housetype` int(10),
`houselabel` varchar(200),
`letway` tinyint(10),
`payway` varchar(30),
`houseareaid` int(10),
`area` varchar(30),
`floor` varchar(30),
`direction` varchar(30),
`decorate` varchar(50),
`year` varchar(50),
`source` tinyint(10),
`housearea` varchar(60),
`address` varchar(60),
`special` varchar(60),
`lng` decimal(10,6),
`lat` decimal(10,6),
`thumb` varchar(200),
`thumb_url` text,
`isrecommand` tinyint(10),
`sort` int(10),
`createtime` int(10),
`content` text,
`name` varchar(50),
`tel` varchar(30),
`salestatus` tinyint(10),
`status` tinyint(10),
`dmoney` float(10,2),
`ispub` tinyint(10),
`ischeck` tinyint(10),
`uid` int(10),
`video` varchar(200),
`cityid` int(10),
`price` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_lethouseprice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`name` varchar(50),
`beginprice` int(10),
`endprice` int(10),
`sort` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_message` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50),
`tel` varchar(30),
`companyname` varchar(50),
`createtime` int(10),
`uniacid` int(10),
`status` tinyint(10),
`uid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_nav` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11),
`advname` varchar(50),
`link` varchar(255),
`thumb` varchar(255),
`displayorder` int(11),
`enabled` int(11),
`cateid` int(10),
PRIMARY KEY (`id`),
KEY `indx_weid` (`weid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_oldhouseinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(200),
`saleprice` int(10),
`perprice` int(10),
`housestyle` varchar(30),
`housetype` int(10),
`houseareaid` int(10),
`area` varchar(30),
`floor` varchar(30),
`direction` varchar(30),
`decorate` varchar(50),
`year` varchar(50),
`source` tinyint(10),
`housearea` varchar(60),
`address` varchar(60),
`special` varchar(60),
`lng` decimal(10,6),
`lat` decimal(10,6),
`thumb` varchar(200),
`thumb_url` text,
`isrecommand` tinyint(10),
`sort` int(10),
`createtime` int(10),
`content` text,
`name` varchar(50),
`tel` varchar(30),
`salestatus` tinyint(10),
`status` tinyint(10),
`ispub` tinyint(10),
`ischeck` tinyint(10),
`uid` int(10),
`video` varchar(200),
`cityid` int(10),
`money` float(10,2),
`dmoney` float(10,2),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_oldhouseprice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`name` varchar(50),
`beginprice` int(10),
`endprice` int(10),
`sort` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`pid` int(10),
`uid` int(10),
`name` varchar(30),
`tel` varchar(30),
`orderid` varchar(100),
`money` float(10,2),
`paytime` int(10),
`createtime` int(10) unsigned NOT NULL,
`paid` tinyint(10),
`status` tinyint(10),
`title` varchar(50),
`type` varchar(30),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_paylist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`title` varchar(30),
`money` float(10,2),
`days` mediumint(10),
`sort` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_saleinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`houseareaid` int(10),
`special` varchar(60),
`thumb_url` text,
`isrecommand` tinyint(10),
`sort` int(10),
`createtime` int(10),
`content` text,
`name` varchar(50),
`tel` varchar(30),
`status` tinyint(10) NOT NULL,
`ispub` tinyint(10),
`ischeck` tinyint(10),
`uid` int(10) NOT NULL,
`type` tinyint(10),
`hits` int(10),
`toplistid` mediumint(10),
`endtime` int(10),
`paid` tinyint(10),
`cityid` int(10),
PRIMARY KEY (`id`,`status`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_save` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pid` int(10),
`uniacid` int(10),
`uid` int(10),
`housetype` varchar(30),
`createtime` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_scorerecord` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`uid` int(10),
`score` float(10,2),
`totalscore` float(10,2),
`createtime` int(10),
`type` tinyint(10),
`content` varchar(50),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`createtime`),
KEY `indx_displayorder` (`totalscore`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_store` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`createtime` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`name` varchar(100),
`logo` varchar(150),
`address` varchar(200),
`tel` varchar(50),
`opentime` varchar(30),
`lng` decimal(10,6),
`lat` decimal(10,6),
`qq` varchar(50),
`email` varchar(50),
`sort` int(10),
`isdefault` tinyint(10),
`cateid` int(10),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_storecate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11),
`advname` varchar(50),
`link` varchar(255),
`thumb` varchar(255),
`displayorder` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`weid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_toplist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniacid` int(11),
`money` float(10,2),
`days` mediumint(10),
`sort` int(11),
`enabled` int(11),
PRIMARY KEY (`id`),
KEY `indx_weid` (`uniacid`),
KEY `indx_enabled` (`enabled`),
KEY `indx_displayorder` (`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_weixinmao_house_userinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`uid` int(10),
`name` varchar(200),
`tel` varchar(60),
`createtime` int(10) unsigned NOT NULL,
`status` tinyint(10),
`avatarUrl` varchar(200),
`wechaname` varchar(60),
`openid` varchar(100),
`score` float(10,2),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

");
?>